SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415052 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415052 [ RunTime:0.003838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157728,870766,523990,147224,302606,556880,166032,1039860,487034,224604,334268,96615,984932,657016,856278,239095,166247,295278,244121,26072,443141,966380,432008,670184,840985,41772,14671,724366,365079,126948,86632,282318,1017802,99672,225714,389913,791539,53876,200838,597979,115503,440807,55064,616206,164338,708135,719377,257172,833799,772478,178276,651496,854316,308354,637401,832987,879362,519949,816269,819836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]