SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527571 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527571 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529645,638114,826726,1034245,475210,662373,567438,250948,216037,979540,528920,641692,663075,478245,1008631,209562,755322,392422,362692,776137,357265,102687,137832,926986,278603,564695,409068,967960,614442,534789,118214,389618,319085,958930,933855,937501,617085,1044178,288211,399382,1005677,668496,71524,642131,644547,109730,539583,349846,968942,907947,940498,263812,511230,156518,733503,142338,475246,238784,813341,863762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]