SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196310 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196310 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883828,192085,875617,630484,64459,582919,428287,989409,933792,446642,1005963,890106,754241,1026241,159812,390988,748420,523697,171441,424394,484349,523645,4789,288492,707082,138983,684393,77529,178702,163581,267369,675041,975130,271504,412342,344177,155922,130764,523936,634341,740873,48251,127240,719620,664907,87599,281938,1003805,977464,987318,380791,177057,447208,18873,79867,127285,229074,461537,629468,550623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001162s ]