SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034392 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034392 [ RunTime:0.001444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985024,34388,714876,740138,183801,800391,899349,502953,43802,728074,1018465,947096,280068,388934,906824,96068,1026563,292645,966257,458216,512101,581456,317492,164310,107826,629962,870985,670333,889427,410692,369547,380261,566601,468562,812749,631029,637596,479144,809492,88243,804411,305717,686700,391006,574608,310798,90469,807219,968140,877223,357976,7395,617886,475578,907174,589903,193161,229858,19965,309708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]