SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103806 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103806 [ RunTime:0.003119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58713,263053,846093,508117,617755,646422,537375,405328,1048608,1030111,823266,1021860,435463,838512,958778,100927,4581,59810,680536,837788,468606,381606,224276,71258,571255,624852,55538,770543,199397,787815,779040,674992,357280,848063,918944,16220,709690,114096,180039,16409,855219,166726,461016,854606,905768,240749,67253,191894,634221,674927,264151,144591,292012,552852,843786,374819,725172,525742,788743,719681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001790s ]