SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384504 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384504 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925779,320998,55894,733186,852757,224618,951099,444064,591732,14321,993841,412177,243379,375221,260735,561505,169311,76135,587557,247446,766375,291295,263950,897800,353766,263672,231034,827479,985935,583550,625959,183571,605136,338262,535607,279327,698884,840583,708057,466569,74813,686216,338073,811918,422378,10929,997969,354721,604558,1025358,913232,1028492,124009,615610,587373,755189,947460,511746,465844,863185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]