SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421843 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421843 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292551,741687,49133,568782,102886,474334,196541,225383,529376,841463,259778,341439,861292,365826,878375,963181,265778,953483,686513,254350,390416,655540,148984,573935,999466,318773,126460,946958,851294,30847,900442,648831,926059,931915,383751,434266,390448,134637,413108,182282,196595,228040,286570,480500,835896,940061,185528,351571,1007796,527582,259,150246,668478,736545,157754,735456,20925,162571,251038,1033483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]