SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284201 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284201 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83491,169292,935476,888743,46873,380634,709355,946751,692638,548450,88665,1018085,690270,417697,1035310,416128,504210,267448,418343,722083,243855,931928,373715,801207,511178,13981,9501,217965,719405,592581,704949,793414,643675,323860,607168,105514,518497,121989,185371,483696,464537,721112,127136,1004005,939909,33466,398932,689218,786778,851150,435199,721855,917796,926953,117727,755466,507092,914551,327346,737174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]