SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421054 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421054 [ RunTime:0.003096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517145,723100,911679,927536,95051,316413,1029373,390035,374879,166031,858649,526892,750600,471988,771385,519770,756991,536570,976086,837146,953512,1041110,201,471219,970717,178289,909640,36923,325785,287893,13988,111592,447074,100118,30665,721670,544223,827902,1033103,727679,132414,796971,387964,936189,40189,248785,889343,701125,1013366,779576,325682,1038080,376923,429516,789514,309296,323952,833139,441860,27396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]