SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521122 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521122 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715403,212237,700301,875795,505016,160639,375294,91782,601172,222782,740978,246369,662177,1005270,737316,853718,836443,868305,154074,414565,456744,240101,568474,80402,487708,234411,229654,906773,582293,822591,505366,608536,262262,566901,259745,102289,263876,762544,229808,706218,902255,106231,945799,519237,588508,38496,809613,331617,725036,398288,480301,698213,900438,705838,646882,121495,842870,87183,992614,960667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003800s ]