SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001861s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543192 LIMIT 1 [ RunTime:0.002194s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543192 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401010,103582,1005949,1037690,513531,718831,287345,468615,968660,772498,808926,1001910,298607,214326,598346,69479,302377,81075,455617,702831,273445,1007269,699144,134365,779340,310711,1043407,305232,1038440,823285,932750,816083,238887,685888,140464,610529,655201,164450,72930,476436,159532,855803,278872,935081,716091,925860,735915,237734,295607,145134,729270,48276,388736,975839,132237,507027,964354,288638,1044578,709412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]