SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508646 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508646 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014014,115148,95632,507604,154525,170493,145526,396290,879421,111243,407635,149846,242537,418233,634865,442615,42940,592525,57841,241880,591493,187395,959429,110201,380453,867998,810979,277393,439853,653286,866880,632002,633171,780554,855837,702523,669493,1820,610281,937073,43027,908421,130817,257136,166661,603783,1000764,212488,868985,941756,728586,382420,138968,277407,263263,656045,698196,800525,209269,276535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]