SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584063 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584063 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408999,602382,194125,59155,487035,677678,190653,183996,180215,460140,897632,244188,230578,224554,524668,145933,628335,904697,169650,5128,722765,572665,461768,1011259,205471,294480,258903,568485,255541,816466,352953,564166,938997,653475,487510,617436,802346,327215,54640,937245,654697,628578,1034545,497573,906805,549773,788333,614040,319869,125115,940918,491481,182962,235270,653850,482338,720350,365978,197417,913151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]