SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101763 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101763 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741049,26273,226179,286925,670792,87927,697616,409054,139638,898214,504699,926093,646696,999205,872874,588658,660229,760182,697935,68633,214851,731417,867459,945361,715667,372659,194216,47155,213604,828337,247621,634790,447770,548239,560627,565678,228800,801826,823881,453050,455985,416606,260854,21907,939334,820811,1000573,730643,666143,456126,462852,377911,686115,363567,1000008,988331,950732,352013,142523,515742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]