SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027398 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027398 [ RunTime:0.002996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484850,812301,1021958,436891,267666,496274,708469,151483,54049,658694,919460,681115,684732,418125,333082,877093,177991,673651,411126,489306,454030,937909,970239,810018,1025180,145292,454749,813043,213706,178170,34893,123975,130996,798309,500977,663210,759188,417448,238074,719960,502739,50772,530782,224773,925089,226767,161665,1002994,594422,354721,771020,783137,712740,476560,981699,712300,1032420,582075,253788,786349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]