SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316543 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316543 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012958,189351,519502,134215,92001,71019,766355,352737,380189,247858,669447,63736,234858,807989,945215,620735,132087,211782,456036,361182,75646,927932,52803,586123,928245,29190,149428,253236,752561,453231,741176,555424,765835,173369,962835,256700,473920,768801,770599,993209,243045,180921,130159,817833,289221,706430,1027116,102922,360183,816642,506577,430221,537973,747418,244933,339102,602464,114058,810599,507457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]