SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478020 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478020 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345038,966038,216856,868958,880852,971395,63033,850220,783335,932709,881982,953679,970116,701486,149116,832791,989670,337468,428896,671868,553298,540070,380997,857355,536363,814360,201164,986878,386213,214851,623528,604223,863616,154424,650528,322829,646958,968696,715051,467989,783111,1012016,864322,815617,34282,796661,614923,131215,330291,876297,200041,847939,788415,155708,760774,523398,355482,177340,290834,1015375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]