SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801970 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801970 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809454,711106,547362,276733,207904,421760,831298,646781,834841,301004,524639,692958,651502,464585,165826,1030281,431964,382952,647148,604229,162550,1019006,558528,408806,837012,756369,189485,193072,619534,32612,564674,380219,649590,59626,13196,690878,790352,852901,787812,174117,1006979,870051,750898,104634,385189,826640,572780,833334,31933,858264,54261,43335,977968,115983,843331,872364,347798,784435,47427,392609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]