SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300413 LIMIT 1 [ RunTime:0.001590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300413 [ RunTime:0.007235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941323,1014726,834575,897063,746144,753038,629842,524670,172373,298350,521319,996868,382535,116488,859712,754557,126826,406995,783031,599224,184797,855780,963120,787841,560133,251287,165919,94090,952298,676467,473480,790322,1003889,16148,349127,1032827,172352,270209,13430,861001,400157,570742,803785,77042,957845,956510,659712,642414,33620,849184,859094,715841,88317,750259,774113,94889,760634,389546,476184,636451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002393s ]