SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50013 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50013 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125108,925962,131534,34142,372291,144682,33343,592324,138578,227971,721974,303746,210627,627507,705594,797549,833959,687185,90918,874097,393080,631927,517283,818791,633506,464321,562159,106456,1044681,830904,462882,889161,459724,348292,932830,98675,508652,614263,499968,843413,484579,264512,983249,933026,92675,139583,290006,765401,174305,353992,168976,788471,507904,648738,257775,611792,122647,165925,830328,58867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]