SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596210 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596210 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208815,663461,1009219,738224,699366,715460,787039,1030506,1006671,833700,601537,1003990,237936,687527,920733,214018,234669,670854,647865,502013,189340,334500,887754,928251,493548,833851,842004,123166,448709,107664,334844,316994,717246,319280,16783,131465,272555,743744,788510,56208,146239,830870,156170,600454,998856,549043,1007613,341190,795488,360835,790845,109675,588109,214847,965742,517836,124374,533812,511759,400040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]