SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50842 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50842 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225379,445059,738931,1039034,218353,237228,1035409,493971,618040,306920,708719,757553,595699,208865,753908,310951,315267,939889,256716,165536,690370,343830,386277,494897,280618,771955,23133,886838,555953,18796,151123,386830,950801,723206,123540,70988,92533,777543,971638,1012298,835567,609437,173797,866591,906299,47633,1032945,383321,793927,167484,706352,723276,606640,196063,251284,275514,570416,400817,489160,191382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001602s ]