SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503841 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503841 [ RunTime:0.008541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501584,342770,1043129,988318,477700,476311,621299,536446,743079,674548,437621,465432,656294,287915,776044,1034061,531560,665887,1028109,1034279,658844,244054,607531,107309,586856,94148,574763,532745,311417,786616,875687,609309,770616,215617,872720,991841,558639,112492,951030,19427,237786,24752,467989,827378,1017354,117329,751201,569968,605346,149848,351114,808056,204073,768513,477310,29885,484624,87671,227245,943987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]