SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581811 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581811 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291293,675066,303952,971392,639626,922938,791465,284037,912118,261526,106632,734882,318449,285389,463521,852769,491131,617914,640834,575559,360638,893847,1013259,300662,94834,48832,721675,733087,529447,623818,68806,174648,665551,287302,919164,135106,410219,913589,631081,394177,233033,528160,768158,222488,149522,724158,387164,499437,884675,888430,867850,174693,104863,66974,65238,428737,51623,1028781,120932,361415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]