SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504078 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504078 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432328,854354,172982,791155,668680,172468,28255,392841,9462,567792,809671,689921,125368,614376,299653,629229,1045102,976333,735785,585153,809111,684978,340007,301295,272723,109506,544923,210932,292157,285693,460312,304520,34333,770128,181964,1047546,59884,694681,916982,37048,484548,584193,682346,907151,2926,267331,800283,17164,79645,375264,450424,265557,984137,238458,942702,689887,335671,420952,898269,919455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]