SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54640 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54640 [ RunTime:0.004996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675006,317208,965466,367423,35158,179872,63294,1007065,645377,409414,509366,214096,768213,162661,145684,896741,372826,866501,172170,660209,437081,673721,220578,300303,330629,479762,1003062,432027,237154,995446,769002,349454,682909,768983,17349,475354,608332,200840,930337,994312,747837,68629,573145,583429,643661,678181,620187,249754,1046721,621336,1039104,390193,516770,946223,362725,161977,261564,197908,461560,6195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000908s ]