SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650460 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650460 [ RunTime:0.002548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144064,247657,1025691,407426,813631,1045620,388375,933758,11818,856715,1045265,855590,726179,674455,844990,152272,609542,457730,149685,521210,551952,475963,193077,172321,630445,604386,181819,957936,305453,8775,1037111,352048,689073,929256,808088,438536,238363,982065,410243,887746,669595,316837,1013728,633288,782722,305082,344317,971781,176707,725376,132813,31251,625519,76251,601217,636684,256443,564229,996051,989145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001544s ]