SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534403 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534403 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311526,652487,851086,762548,414303,523164,347342,23331,992824,634306,1000085,57234,28309,405411,4170,937693,325142,589291,725730,80037,528606,706090,518359,646428,769856,39825,981180,50348,257968,127039,616973,778813,206707,576189,591438,218692,429406,1018659,397522,770435,578248,647122,551624,9898,540952,425298,619988,577436,522872,288968,836299,88065,92366,681838,131778,1048499,448040,746790,753677,863073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]