SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563875 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563875 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335005,13226,534695,58573,212626,380879,670106,929610,982820,1038833,448907,1005252,468651,64706,600226,926772,186312,92658,655652,39296,219657,617494,28865,454122,757387,12622,234422,1031079,93444,585641,353872,384013,525601,279478,971600,584495,470105,243405,153320,940362,957738,889662,655488,470544,802731,167439,1018041,677691,353469,380896,868155,12975,944943,862334,687016,946094,202054,69974,131700,138099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]