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` = 575448 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575448 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843324,1040698,249092,136109,498714,228391,680953,774277,602415,426317,585774,291845,119652,644860,570228,451809,902713,846472,374434,190028,550045,232795,168410,912958,821381,607121,806276,371217,1022276,338297,430253,778087,826186,859705,987868,54499,590301,679217,730621,439169,720179,471992,970103,363978,610477,232489,311329,903837,945387,920792,974418,912816,1002293,624748,616566,979020,162771,235312,684819,1028349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]