SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000191 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000191 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292086,1013020,548349,943094,804639,67387,993187,509186,516779,899359,105906,505734,944960,548410,570004,807447,813805,186244,307315,634104,1033403,1014690,708384,352058,56324,151120,806293,852993,690670,326940,67409,219864,118517,667217,52525,701848,125460,1037196,554424,388901,262796,56073,191712,716797,323879,169808,754696,848853,15492,37153,286179,386255,31490,901747,922644,1003559,814518,299578,146144,204944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001028s ]