SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48607 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48607 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31194,465156,40390,566061,149713,150980,471156,94927,934743,894149,387634,1034306,339982,843654,265984,40999,758706,729445,922895,490884,117734,901221,12523,726041,103543,99186,320204,408973,940303,163770,98730,374927,73122,518411,383548,427607,847255,246120,10242,134052,1015763,114235,314018,148631,924763,151164,807613,809534,119155,409094,240029,98501,802823,259567,984467,992891,708369,581644,14639,358493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]