SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003918 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003918 [ RunTime:0.003319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690754,145860,233986,1034132,965619,456428,742991,948748,94900,39322,753929,405262,1036298,743105,77494,478331,308040,6660,598261,968775,176490,710300,106945,470932,966474,721503,385474,512256,967810,537657,1043635,222195,571411,607356,137504,506843,135243,754142,123238,698540,266058,135247,820458,538364,402245,79884,244123,959369,796810,976118,562425,668055,169512,28733,734044,194251,112338,137874,769098,647197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]