SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591980 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591980 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595048,318224,270773,542586,279954,118998,258119,28432,930758,66723,134404,433362,939453,276176,680581,719635,177953,575292,35134,606897,637100,792902,85913,871277,907862,651330,235461,380263,918853,966801,1032727,735824,1034958,457728,86781,576629,247692,80406,353077,593386,503935,292176,635252,750979,707358,498022,240359,388508,937058,774432,620688,863580,373062,193576,420583,869799,356214,895281,755496,548379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]