SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241480 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241480 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945012,752669,169873,185010,390032,69383,842855,186474,991713,204575,745772,769221,820564,971305,357980,1040211,124270,493526,868640,941723,295346,225162,354099,371941,185212,127730,64446,656858,114313,873843,752374,1002004,484671,325296,377820,170324,750799,333040,881293,903599,210652,36732,249811,727711,379364,404212,738842,164866,399076,711628,664641,382839,529872,412293,536587,723233,884675,244028,604176,188024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]