SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521612 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521612 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459211,867438,50267,356857,40787,352380,770222,833753,103461,724257,762504,205227,138543,1032081,584659,804228,1017848,255547,965904,841481,551349,960534,336151,470758,571453,988433,886116,821738,460783,24095,32488,681633,381440,17276,847107,554433,14097,20722,286203,530099,354225,713644,902128,319209,170880,328496,333462,803655,796519,481019,539352,458005,214731,168622,562671,604843,949457,228052,10719,186579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]