SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498621 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498621 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365262,126865,204719,410097,448484,167465,421136,294807,335170,286724,939312,963900,668336,842787,985050,721949,643967,395360,329466,230789,878773,919204,678038,967452,812183,753998,487310,381799,534376,341188,201615,895387,661335,468097,146485,313799,728159,78828,1024392,1021321,840921,390161,10232,707418,937015,326942,997273,547364,712325,774347,793813,640162,580312,145414,1048241,50552,19491,287228,736004,720231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001294s ]