SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319736 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319736 [ RunTime:0.006066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836749,4216,177693,529980,328230,597625,485035,979213,1011303,1045251,502238,1006904,850075,252385,215150,571403,126245,690299,915454,391228,240569,541594,386462,603790,438742,432532,198282,416166,601145,790029,1020132,986513,717526,786923,2644,699280,640812,456268,948368,166854,331847,1042207,1047200,967547,120775,184749,939253,4453,504638,166139,643809,640208,420231,431526,479456,67018,594198,710779,533211,661067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]