SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458235 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458235 [ RunTime:0.003068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415225,114383,560806,145992,554758,332334,56017,521721,765555,607815,14781,971241,184545,707352,288267,200480,836076,12613,678233,948059,100248,254292,373675,688305,154437,582855,337720,434298,583139,507858,297704,514172,950654,584268,10756,789649,73104,645618,45247,15645,536653,108199,817567,90182,48125,805570,733714,730602,912937,60670,640938,590919,589685,229972,33397,381237,580322,246279,477030,727629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]