SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021878 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021878 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042761,981858,819970,397089,666029,354446,645975,787489,852168,536451,394366,720812,641645,907760,106672,454439,369263,724956,942947,998614,27216,139486,139568,27874,511579,43711,385274,931784,874259,710496,698057,667690,389972,121837,440527,456350,163443,500070,442516,793144,42628,79583,129564,656112,361880,658702,467618,117776,622178,51922,592170,563493,140585,318513,992914,290823,114993,983363,748525,867330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]