SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 363643 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 363643 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501033,342227,377588,666862,967061,605984,972584,395748,742923,719285,81457,524942,283191,335761,1046434,201342,928212,942438,980654,986235,906747,127127,290100,310302,973549,920730,124635,986684,672772,504232,143670,96116,209836,798341,835484,144422,658263,647084,804897,599772,276672,540301,72866,978489,629293,692007,473159,772233,1043865,340483,604777,333767,549718,956094,750786,46143,885025,1039864,490281,749287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 363643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 363643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001127s ]