SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401965 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401965 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155434,435796,682916,377494,818684,186881,767538,86954,540707,1038862,814323,737895,106545,37393,81688,140264,540699,153770,730926,260616,177028,666223,189646,939275,523846,1036455,305895,368375,59199,349873,445098,1008658,516862,601280,192430,854051,1036355,319530,562617,982364,745604,705850,27703,339052,225513,23181,309613,228880,690863,423152,283824,43674,258827,929498,631982,846140,854870,235760,163893,625859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]