SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 867183 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 867183 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36187,738492,464014,575419,992334,189276,1001095,68980,343416,1039525,948815,552887,883917,900882,120051,382121,618454,453039,38499,863948,310094,965362,416250,605206,895022,910701,774772,57169,153011,245070,359475,1022933,461740,341453,717185,1015969,493991,368850,611893,449581,864420,968678,651010,802251,1030495,82847,425459,224606,711104,823720,702953,432708,1017835,448180,292579,803807,583585,746992,913990,1044169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 867183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 867183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]