SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020079 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020079 [ RunTime:0.002806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513848,729759,332142,129108,1006719,427873,647270,428059,676739,387829,925662,592843,237418,258386,775740,209102,184962,133239,383166,18440,519542,963983,953517,569376,771653,267094,489518,514868,854522,430005,265402,507905,965777,795288,279956,653938,671795,492320,970342,393553,834940,313394,971875,23008,563768,1027444,465948,952857,95645,165187,915740,869760,395298,260076,104437,628493,424698,268679,815704,554393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]