SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184118 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184118 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141486,405550,156884,791048,314269,663431,424203,983297,187708,532000,724291,541294,243714,281569,477618,456545,719825,263463,493437,423447,390123,513116,544218,674455,840970,146176,937211,935942,577579,546172,255137,827763,232207,80988,284002,667006,680231,448069,771909,269504,40954,75487,954587,925484,561932,497509,557562,805348,46893,1041975,938081,65039,213004,641564,102590,244028,2574,400321,569941,516174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]