SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301187 LIMIT 1 [ RunTime:0.001132s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301187 [ RunTime:0.003416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830080,805409,233203,255255,840418,1016817,520021,833410,744361,278484,725428,7208,960219,251134,755584,4155,980757,396456,638911,852173,581094,200860,610737,616727,860562,908988,1018554,154956,800738,106452,494622,600755,231430,261898,325488,36841,204138,936008,793877,107363,743826,539969,738274,352403,278152,427963,309511,80960,182741,993277,656177,882689,989195,1044778,295147,856727,851880,386704,663105,396121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]