SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501802 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501802 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522864,435139,610735,34090,784597,923124,222873,810677,791361,562282,862984,216657,544140,878994,316708,785868,443284,841132,446967,744821,923320,981626,151575,631676,446635,393437,53685,533061,348042,377647,997612,927182,182967,83552,396150,705297,428843,832369,536595,692695,118468,460216,667634,577359,792347,326682,318333,191824,1042017,252072,1037280,392709,657110,576699,998242,874652,435714,684875,201542,758749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]