SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310820 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310820 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517300,520475,607113,736711,510644,982732,126199,71858,811805,572969,249106,132095,1039727,947993,862986,207704,954741,207833,446700,20067,470104,918628,1023621,235765,732514,238354,1005733,908569,821529,171463,1043609,1036052,381386,135714,68673,41952,142822,848087,130585,374585,1030111,271237,912454,595395,481354,371775,732680,111443,940446,259069,467001,601913,499484,460899,648554,42077,593822,805201,926534,1039758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]