SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001060 LIMIT 1 [ RunTime:0.003993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001060 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523796,164011,67526,828317,280122,125651,824298,71585,715595,602076,920728,622851,938481,966247,481446,327838,938789,968498,107028,223404,237781,303266,1030000,298293,897994,164667,9996,18118,673229,24954,26623,405258,615565,855186,291884,743520,526550,190706,337350,33334,153675,885932,781764,308780,831232,922936,633958,475587,233472,168468,783528,463592,666519,977387,692940,416314,192138,231337,764806,572309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]