SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686048 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686048 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5859,72390,631425,779718,697567,333961,963726,841052,964789,546903,570781,374257,946818,628336,850227,431950,302096,215042,169843,917491,943274,637880,193954,672742,344572,502860,436641,272544,929481,431717,68240,781697,375289,68534,907439,898887,514255,815281,340067,113275,464519,194801,755228,62012,688104,121643,872580,527947,423874,790272,555904,207811,1027272,310177,185688,857368,148521,599725,253369,213918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]