SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476881 LIMIT 1 [ RunTime:0.000960s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476881 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510525,798515,396516,741643,292056,732200,411717,920583,333072,890044,946634,795316,123314,185338,150666,234365,96802,588677,842478,734759,89832,1036488,841832,360254,870786,184026,127673,73749,795641,410999,350797,771879,163416,224121,308900,659525,532749,232774,333666,597377,815874,596389,61522,166360,1039073,568904,1010190,1010604,721637,284913,531288,540357,926964,855005,173139,682220,788539,495229,330536,1020022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]