SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842812 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842812 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453395,147400,20963,307622,462794,60689,163075,705167,455678,164434,1008620,629169,584849,417712,882877,697380,754142,212476,539342,776082,566012,939041,1047927,209808,243852,577091,953205,288692,989677,711461,341495,173255,101759,606698,122008,100915,794659,854212,93043,147137,168236,156600,416094,319895,477480,174286,475696,798713,954023,416977,438567,751383,606996,817499,796402,5538,883004,580733,142219,254526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]