SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40510 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40510 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647993,826349,683322,126816,803771,975291,66961,938053,1039779,1017993,481535,192207,710653,911079,280662,834424,832044,110069,97865,387140,416417,378436,279397,389558,277149,470433,872125,507938,997196,998977,459392,638139,1017600,814416,989325,798424,17634,818765,537453,391051,436512,6431,807061,912537,839130,823612,493544,662255,68201,24751,750027,809218,88109,951793,304938,700903,69983,256334,492094,100062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]