SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472416 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472416 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42869,674941,133620,397144,1016905,156390,257150,385983,874022,507202,820843,389541,55565,321773,790363,998922,379577,771260,738021,720460,231971,565642,64628,153590,982779,409068,565529,305512,1023382,813027,268170,448652,478593,295148,556446,942716,843771,820252,819836,417593,811038,247491,257144,754129,331932,898841,175323,419974,487782,543491,600826,58022,874540,726388,338313,939486,840238,389503,856471,354718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001383s ]