SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491274 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491274 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031691,953884,363023,107725,510085,328142,387949,817863,156010,116154,550735,220691,537430,515768,367106,224762,169840,1019803,478036,931110,284332,60342,652694,35907,436101,1022865,1039445,181326,193898,1005963,599784,558878,16979,679151,635554,828880,984796,323043,284773,352964,823769,944140,1035656,100534,413040,603221,205878,636614,962267,888846,308801,226218,1045176,582948,1030295,550329,109607,1018746,512447,906986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]