SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500462 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500462 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454712,40836,722010,873171,1019965,138068,1041260,1020879,262566,253654,451761,600427,491777,760713,113067,482612,693719,82443,323850,568078,354722,969854,830526,340176,103713,439621,97847,908607,335183,1019816,928953,278321,266700,134184,755561,731064,176026,97098,888974,518934,297743,592563,540187,735081,557635,196489,423234,201440,380465,837445,777064,847208,761901,618321,704924,422200,516736,665636,864018,351298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]