SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545757 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545757 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33608,593242,625180,499390,152138,909226,906531,336699,624710,738172,538840,1035959,699204,576333,437075,984947,765810,938057,210046,261383,859559,301997,811257,432544,138551,986537,201897,247203,462850,375819,907826,922043,819051,905232,837954,479145,62974,913512,833107,427516,437540,159347,292603,725800,16457,580562,1000869,458373,474498,371838,753939,641051,873403,674701,5283,554007,467632,491693,662014,513641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545757 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545757 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]