SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002869s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531960 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531960 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375647,517500,913656,974228,454393,909067,808990,672247,69634,42490,595940,892312,548658,956701,883548,18617,16610,462926,864542,535103,809611,999873,333017,193907,442733,111359,944778,643034,60333,785656,857659,1006527,470719,471448,856647,362927,864876,37612,656749,736154,831288,686175,1039657,339662,1041727,235669,409684,195298,455515,796226,791498,234458,393620,863062,759155,1024666,303623,307419,553836,538521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]