SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450450 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450450 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465898,650618,358973,344840,353597,631590,242206,760736,918775,403530,1022200,281167,692233,755369,855848,603213,67146,495598,803712,725731,267564,541716,331654,365995,912478,905928,469337,682119,534816,454682,831887,206102,656009,760738,341487,522519,456039,41904,526529,203472,247543,146701,477496,365137,834141,304605,861571,913870,850290,756916,463632,236974,617297,754949,621978,628799,335459,306351,214874,91875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]