SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021017 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021017 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969237,219123,680228,92944,507246,32970,4060,60094,459785,753302,29432,577526,946776,329247,607795,21545,340562,151754,1042054,589721,688113,757977,234916,181640,229050,109387,35564,619315,440435,389656,573091,288537,951784,137813,98599,860195,342651,157961,426814,852447,159575,749655,164044,848274,887716,907972,317260,308241,234539,821479,900783,220333,555881,684376,524131,180585,456244,937616,280925,475748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]