SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540035 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540035 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231755,1009913,579980,759455,878244,584998,682186,966570,349551,563733,220716,488788,35392,536116,19280,547335,86731,543829,735023,1027163,259721,840795,134560,922431,583636,756851,319736,386002,745944,87246,412089,474085,75266,749549,493039,801760,882364,233943,155828,717314,466913,496809,380299,825452,990981,433567,272107,766854,14636,457256,507682,300787,549093,792993,216559,238344,246978,896506,675557,216690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]