SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450028 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450028 [ RunTime:0.003403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487502,187487,20647,156634,862725,512788,86803,1048723,759487,903035,440533,277896,351723,169484,643311,596208,640729,457445,538528,386019,132323,387774,898304,928782,731046,168585,848789,713409,171099,409665,567101,697689,312744,968894,848045,712627,965876,218962,765355,402883,379980,981251,802489,668732,608837,420044,296885,672450,939515,469826,852598,332253,92952,1046518,419651,945049,562967,121786,521398,99101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]