SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190979 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190979 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299763,771676,1025636,166671,947968,771930,421978,578804,227061,1040566,243708,804764,547560,947732,141202,88931,64456,857586,705663,480937,173979,251853,547012,630615,118133,805558,212528,731245,367954,190277,928697,443035,476798,1011462,300422,906196,33170,342094,384394,830406,65364,188559,1018145,236419,884915,487590,49573,398650,99726,802861,480813,468101,348206,690836,377711,503872,1024617,32800,85974,451376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]