SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489191 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489191 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118632,93953,924098,230735,485899,848682,267399,205430,732747,121656,625145,441700,16811,82443,23757,603595,128454,830073,579439,102641,59362,170625,798255,879829,874489,1020700,709934,161276,142530,333764,315882,572652,740987,451306,483884,315621,555884,745805,226748,500477,784211,608322,755469,237231,952121,930639,342742,701133,655897,82893,823889,498216,479590,381981,380540,983878,856882,784754,924023,753794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]