SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589593 LIMIT 1 [ RunTime:0.001372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589593 [ RunTime:0.002443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908073,666314,903604,571524,814763,951906,354425,569801,375077,586470,988022,440146,375071,639103,364578,933615,172340,719739,891395,437300,762371,732173,393118,757743,201476,431145,995347,182217,535770,534314,1036800,564633,580473,261582,706347,399524,666439,719842,544168,41975,334423,684867,516688,122979,572685,261985,1035826,149633,538308,51656,414382,245695,50154,43729,566105,249568,624409,916090,158917,186584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]