SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545352 LIMIT 1 [ RunTime:0.001960s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545352 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179280,44157,206308,858040,380974,939594,700230,377092,719600,417081,916535,560125,710905,1048309,209094,222024,601749,837621,216599,347778,640616,477973,309735,794645,722736,564478,569020,435240,414875,163984,474214,830048,1022568,720403,1040068,781632,963800,1010997,741055,803671,93187,247468,122916,707366,368238,197098,637895,108568,83376,319060,317950,997125,1004420,396189,518241,206700,670922,909331,402288,271990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]