SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342501 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342501 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630930,101055,959556,107015,400655,729713,944750,858129,326022,717220,1016850,944677,441237,282972,125264,851282,52711,955592,743645,65719,1001576,874363,768704,820232,599812,722139,17677,34806,118637,599151,898828,647604,211840,593787,48301,796991,1022322,932165,47181,826630,703099,943765,179922,635843,410808,721639,850705,180803,310344,935203,899834,447905,377999,229803,422074,751095,125358,77404,680516,706773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]