SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030081 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030081 [ RunTime:0.005503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250438,798491,325396,862475,879883,146078,220498,596330,546917,262765,706855,818904,1035947,166776,372075,24752,473227,985190,361387,53792,510211,512449,814452,391549,50621,890824,738391,226698,324105,37616,494340,650943,176060,78523,786566,185656,432629,723243,1019557,105522,80753,239466,147630,433759,893927,125260,1047020,257570,189151,476838,566762,803705,416608,917141,39851,333279,46834,248789,952245,561440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]