SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193843 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193843 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718996,443144,584645,369816,524126,734804,104045,107996,356386,929841,549538,509630,73109,440840,769324,98769,225075,982523,340653,44286,932328,864130,454037,741676,510343,789838,368797,304203,826726,541259,13534,705733,471198,281770,693932,50760,618987,732963,866023,1023974,641864,235071,648163,634340,201329,620781,422998,757265,167422,1020063,575106,161499,144994,951507,563069,924125,201754,173771,457402,337460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]