SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413447 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413447 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607061,342730,348824,232530,122102,333917,740133,457148,664833,801517,482043,332965,944063,410796,676296,34770,1003183,554978,523897,729133,110459,328945,732782,16770,965939,156620,778740,195875,618890,725324,190136,558185,509641,664660,706733,837842,157617,367741,747386,49191,906799,882806,817101,323075,608342,42734,568370,574168,658722,986394,188557,571024,50719,516469,522719,252359,599890,986425,820709,581776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]