SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409528 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409528 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413952,37330,72803,205969,568785,379179,974822,145288,398233,178808,981246,596195,332812,826366,953219,1012122,180949,358884,519769,884191,9641,935431,1032437,151380,808667,797455,170499,53892,587787,125743,390437,986084,437445,48305,417820,175506,958328,313752,380677,354851,771837,885313,878557,237437,10941,621803,1047844,647567,57375,414100,117480,413631,650194,29001,57410,495633,633565,285695,376550,102346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]