SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419083 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419083 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968771,916182,23068,717535,743456,481525,69601,10337,817682,210580,179844,726201,253899,675983,268565,762073,784161,51533,527977,399216,664530,184871,661042,212205,15454,76328,758233,988343,661885,314250,1013255,779065,848114,85903,267029,366849,561312,440882,96372,772621,959478,139577,71824,274177,254307,168978,188667,650141,318776,190996,664566,602463,609009,126042,737522,500728,417189,860090,1029848,758278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]