SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412647 LIMIT 1 [ RunTime:0.001894s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412647 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509617,89485,206560,427186,200951,272650,94431,287406,755259,863616,630489,502685,14218,310179,656316,826420,140834,959101,1045827,710717,732285,39931,175613,360189,1003661,451309,224850,734740,906926,650305,865466,569465,119872,182341,359584,164044,363894,404830,939561,279540,161008,725510,222533,550417,243941,131436,150944,63507,275151,890036,85662,936425,423900,600734,506320,652173,966706,939831,686696,1007856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001499s ]