SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331321 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331321 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440410,480716,333782,535380,571864,374214,20479,1040510,457285,590804,305790,100083,26164,641765,55545,1042835,345467,694215,199452,514117,209305,437797,417797,701621,855487,575527,933218,642869,504056,140376,44301,640667,999807,537037,351537,978704,83953,209434,90428,51184,819834,535467,665458,295452,953902,397528,418917,340031,834626,661631,800281,643390,690158,877821,1040286,619779,471462,121967,898444,699261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]